MatchedRows Function

Syntax

the matchedRows of <dataSheet>

where "condition" Applies to datasheets

Description

Like the matchedCols function, matchedRows is a query function that returns a comma-delimited list of numbers that correspond to the rows of a dataSheet that satisfy the given constraints. The constraints are specified using a string expression. You can use several constraints joined by logical operators. Each constraint must use the following format: [not] <column> [= | > | < | etc.] value

Examples

You can use the matchedRows function to find matching data with spaces in it. For example, & QUOTE matches a cell containing Hello World. Column 2 will be searched for values that are greater than Smith and column 5 will be searched for values greater than 32000. The resulting string of matching row numbers will be put into the variable selectedRowVar.